package com.yxy.model;


import lombok.Data;
import tk.mybatis.mapper.annotation.KeySql;
import tk.mybatis.mapper.code.ORDER;

import java.util.Date;
import java.math.BigDecimal;

import javax.persistence.*;


@Data
@Entity
@Table(name = "table_client",schema = "")
public class TableClient {

  //id
  @Id
  @KeySql(useGeneratedKeys = true,sql = "SELECT @@IDENTITY",order = ORDER.AFTER)
  @Column(name = "id")
  private Long id;

  //用户账户 用来顾客登录之后查看个人信息
  @Column(name = "user_account")
  private String userAccount;

  //顾客头像/图片
  @Column(name = "client_image")
  private String clientImage;

  //顾客编号
  @Column(name = "client_code")
  private String clientCode;

  //顾客姓名
  @Column(name = "client_name")
  private String clientName;

  //顾客身份证
  @Column(name = "client_card")
  private String clientCard;

  //顾客电话
  @Column(name = "client_tel")
  private String clientTel;

  //顾客生日
  @Column(name = "client_birthday")
  private String clientBirthday;

  //顾客性别 0为男，1，为女
  @Column(name = "client_grander")
  private Long clientGrander;

  //顾客微信
  @Column(name = "client_wechat")
  private String clientWechat;

  //入会时长
  @Column(name = "member_length")
  private Long memberLength;

  //会员类型
  @Column(name = "member_type")
  private String memberType;

  //标记数据状态 0 不显示 1显示
  @Column(name = "status")
  private Long status;

  //数据备注
  @Column(name = "misc")
  private String misc;

  //创建者id
  @Column(name = "create_user_id")
  private Long createUserId;

  //创建人姓名
  @Column(name = "create_user_name")
  private String createUserName;

  //创建时间
  @Column(name = "create_date")
  private Date createDate;

  //修改人id
  @Column(name = "update_user_id")
  private Long updateUserId;

  //修改人姓名
  @Column(name = "update_user_name")
  private String updateUserName;

  //更新时间
  @Column(name = "update_date")
  private Date updateDate;


  //上次升级时间
  @Column(name = "upgrade_date")
  private String upgradeDate;


  //varchar预留字段1
  @Column(name = "param1")
  private String param1;

  //预留字段2
  @Column(name = "param2")
  private Long param2;

  //预留字段3
  @Column(name = "param3")// 数据库里面实实在在存在的字段
  private BigDecimal param3;//java 声明的变量





}
